[dbo].[Name_Lookup]

Property	Value
Created	3:12:44 PM Friday, January 07, 2011
Last Modified	11:40:04 AM Monday, February 20, 2012

Property

Value

Created

3:12:44 PM Friday, January 07, 2011

Last Modified

11:40:04 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key pkName_LookupID: ID\SEQN$	ID	varchar(10)	10	('')
$Cluster Primary Key pkName_LookupID: ID\SEQN$	SEQN	int	4	((0))
	Field1	varchar(50)	50	('')
	TIME_STAMP	timestamp	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key pkName_LookupID: ID\SEQN$

varchar(10)

('')

$Cluster Primary Key pkName_LookupID: ID\SEQN$

SEQN

int

((0))

Field1

varchar(50)

('')

TIME_STAMP

timestamp

	Name	Columns	Unique
$Cluster Primary Key pkName_LookupID: ID\SEQN$	pkName_LookupID	ID, SEQN

Name

Columns

Unique

$Cluster Primary Key pkName_LookupID: ID\SEQN$

pkName_LookupID

ID, SEQN

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

Type

Action

Owning Principal

Grant

Delete

IMIS

Grant

Insert

IMIS

Grant

References

IMIS

Grant

Select

IMIS

Grant

Update

IMIS

SQL Script

CREATE TABLE [dbo].[Name_Lookup]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Name_Lookup__ID__42C5EC20] DEFAULT (''),
[SEQN] [int] NOT NULL CONSTRAINT [DF__Name_Looku__SEQN__43BA1059] DEFAULT ((0)),
[Field1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Name_Look__Field__44AE3492] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Name_Lookup] ADD CONSTRAINT [pkName_LookupID] PRIMARY KEY CLUSTERED ([ID], [SEQN]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Name_Lookup] TO [IMIS]
GRANT SELECT ON  [dbo].[Name_Lookup] TO [IMIS]
GRANT INSERT ON  [dbo].[Name_Lookup] TO [IMIS]
GRANT DELETE ON  [dbo].[Name_Lookup] TO [IMIS]
GRANT UPDATE ON  [dbo].[Name_Lookup] TO [IMIS]
GO